Tabela Cost

Definicja tabeli Cost

Name

Cost

Code

Cost

Comment

 


Lista kolumn tabeli Cost

Name

Code

CostID

CostID

CostTypeID

CostTypeID

ServID

ServID

ResourceID

ResourceID

StartDT

StartDT

StopDT

StopDT

UnitCost

UnitCost

Description

Description

Comments

Comments

OverheadsCalc

OverheadsCalc

DirectCostUpperLimit

DirectCostUpperLimit

DirectCostLowerLimit

DirectCostLowerLimit

MaxPrice

MaxPrice

MinPrice

MinPrice

StdDev

StdDev


Kolumna CostID tabeli Cost

Definicja kolumny CostID tabeli Cost

Name

CostID

Code

CostID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CostTypeID tabeli Cost

Definicja kolumny CostTypeID tabeli Cost

Name

CostTypeID

Code

CostTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli Cost

Definicja kolumny ServID tabeli Cost

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceID tabeli Cost

Definicja kolumny ResourceID tabeli Cost

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Cost

Definicja kolumny StartDT tabeli Cost

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Cost

Definicja kolumny StopDT tabeli Cost

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna UnitCost tabeli Cost

Definicja kolumny UnitCost tabeli Cost

Name

UnitCost

Code

UnitCost

Data Type

FLOAT(48)

Mandatory

No

Comment

 


Kolumna Description tabeli Cost

Definicja kolumny Description tabeli Cost

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna Comments tabeli Cost

Definicja kolumny Comments tabeli Cost

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna OverheadsCalc tabeli Cost

Definicja kolumny OverheadsCalc tabeli Cost

Name

OverheadsCalc

Code

OverheadsCalc

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna DirectCostUpperLimit tabeli Cost

Definicja kolumny DirectCostUpperLimit tabeli Cost

Name

DirectCostUpperLimit

Code

DirectCostUpperLimit

Data Type

FLOAT(48)

Mandatory

No

Comment

 


Kolumna DirectCostLowerLimit tabeli Cost

Definicja kolumny DirectCostLowerLimit tabeli Cost

Name

DirectCostLowerLimit

Code

DirectCostLowerLimit

Data Type

FLOAT(48)

Mandatory

No

Comment

 


Kolumna MaxPrice tabeli Cost

Definicja kolumny MaxPrice tabeli Cost

Name

MaxPrice

Code

MaxPrice

Data Type

FLOAT

Mandatory

No

Comment

Na potrzeby wyliczania maksymalnych kosztów zasobów


Kolumna MinPrice tabeli Cost

Definicja kolumny MinPrice tabeli Cost

Name

MinPrice

Code

MinPrice

Data Type

FLOAT

Mandatory

No

Comment

Na potrzeby wyliczania minimalnych kosztów zasobów


Kolumna StdDev tabeli Cost

Definicja kolumny StdDev tabeli Cost

Name

StdDev

Code

StdDev

Data Type

FLOAT

Mandatory

No

Comment

Na potrzeby wyliczania odchylenia standardowego


Lista kluczy tabeli Cost

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Cost

Definicja klucza Identifier_1 tabeli Cost

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment